from common.models import db
from datetime import datetime

# 创建 User（用户）模型类:
class User(db.Model):
    __tablename__ = 't_user'
    id = db.Column(db.BIGINT, primary_key=True, autoincrement=True)
    username = db.Column(db.String(64),doc='用户名')
    password = db.Column(db.String(64),doc='密码')
    icon = db.Column(db.String(5000),doc='头像')
    email = db.Column(db.String(100),doc='邮箱')
    nickname = db.Column(db.String(500),doc='昵称')
    phone = db.Column(db.String(11),doc='电话')

    login_time = db.Column(db.DateTime,default=datetime.now(),doc='登录时间')
    create_time = db.Column(db.DateTime,default=datetime.now(),doc='注册时间')
    update_time = db.Column(db.DateTime,default=datetime.now(),onupdate=datetime.now(),
                            doc='修改时间')
    status = db.Column(db.Integer,doc='用户状态')

